Having Said that the subsequent aspect I'm struggling to complete once the mass copy and paste has run I would like A different code that could update column A accordingly these types of that the Job num from sheet 2 will fill in to each between jobs 2 and ten,000 Successfully Submitted (Awaiting Approval)